package com.rgs.ssm.dao;

import com.rgs.ssm.domain.Traveller;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @create 2021-02-17 21:07
 **/
public interface ITravellerDao {

    /**
     * 多表操作，由订单的id返回该订单的有课信息
     * @param orderId
     * @return
     */
    @Select("select * from traveller where id in (select travellerId from order_traveller where orderID = #{orderId})")
    List<Traveller> findByOrderId(Integer orderId);

}
